package com.tsd.common.dao;

import com.tsd.common.entity.CommonFile;
import com.tsd.common.entity.CommonFileExt;
import com.tsd.core.vo.PageBean;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * 描述：CommonFileMapper
 *
 * @author huawei
 * @date 2021/08/08 20:40:38
 */
public interface CommonFileMapper {

    CommonFile selectByPrimaryKey(Long id);

    CommonFileExt selectBySid(String sid);

    int deleteByPrimaryKey(Long id);

    int insert(CommonFile record);

    int insertSelective(CommonFile record);

    int insertList(List<CommonFile> list);

    int updateByPrimaryKey(CommonFile record);

    int updateByPrimaryKeySelective(CommonFile record);

    List<CommonFileExt> selectByEntity(CommonFile record);

    List<CommonFileExt> selectByPage(@Param("params") Map<String, Object> params, @Param("page") PageBean page);

    List<CommonFileExt> selectCount1Page(@Param("params") Map<String, Object> params, @Param("page") PageBean page);

    List<CommonFileExt> selectByParams(@Param("params") Map<String, Object> params);

    List<CommonFileExt> selectBySidList(@Param("sidList") List<String> sidList);

    List<CommonFile> selectByBizType(@Param("biz_type") String biz_type);

    List<CommonFile> selectByOwnerSid(@Param("owner_sid") String owner_sid);

    void updateAssociateData(CommonFile record);

    void updateList(@Param("list") List<CommonFile> list);

    List<CommonFile> getFileInfoByBizSidAndBizTable(@Param("associate_biz_sid") String associate_biz_sid, @Param("associate_biz_table") String associate_biz_table);

    void updateDrBySid(String sid);

    CommonFileExt selectExcelTemplateByBizSid(@Param("associate_biz_sid") String associate_biz_sid);
}
